-- #lazgen HEADER#
/*
	spTechnologyGet.

	This procedure returns a single Technology from the database, based on a specific primary key value.
*/
SET ANSI_NULLS ON
GO

ALTER PROCEDURE [spTechnologyGet]
(		
	@id INT

) AS
		
BEGIN
-- #endlazgen HEADER#

-- #lazgen BODY#

SELECT
	[technology].[Id],
	[technology].[Title],
	[technology].[Description],
	[technology].[ExpertiseLevelId],
	[technology].[Created],
	[technology].[Modified]
FROM
	[tblTechnology] [technology]
WHERE
	[technology].[Id] = @id

-- #endlazgen BODY#


-- #lazgen FOOTER#

END

GO

SET ANSI_NULLS OFF
GO   
-- #endlazgen FOOTER#
